Parameters

Database Instance Name

Enter the unique instance that was specified in the **Define Database Connection** command.

Required

Define Query Execution Type

Select the appropriate query execution type.

Required

Query

Define the OleDb query to execute.

Required

Query Parameters (Optional)

Define the query parameters.

Timeout (Seconds)

Specify how many seconds to wait before throwing an exception.

Required

Output Dataset Variable

Create a new variable or select a variable from the list.

Required

Private (Optional)

Optional field to mark the command as private (data sensitive) in order to avoid its logging.

Error Handling

Optional field for how to handle errors encountered.

Required

Comment Field (Optional)

Optional field to enter a custom comment which could potentially describe this command or the need for this command, if required.